Column headings not in desired order due to placement in query design grid.
Cause:
In the Query Design view, the desired field names were not inserted in the desired order.
Solution:
In Query Design view, move the desired fields to another location using the mouse.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query in the list box. (The selected query is highlighted.)
4) Click 'Design'. (The query appears in Design view.)
5) To change the order of the fields in the query grid, do the following:
a) Position the mouse pointer above the field name in the 'Field' row to be moved. (The cursor changes to a black down arrow.)
b) Click mouse button. (The selected column is highlighted.)
c) Hold and drag the mouse pointer to the desired location. (A vertical line moves with the mouse.)
d) Release the mouse button at the desired location. (The selected column appears in the new location.)
e) Repeat steps 5)a) through 5)d) for each column to be moved.
6) Select the 'File' menu and select 'Save' to save changes to the query.
